﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="order_sqlcount.aspx.cs" Inherits="ihongma.Web.admin.order.order_sqlcount" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>订单管理</title>
<script type="text/javascript" src="../../scripts/jquery/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="../../scripts/lhgdialog/lhgdialog.js?skin=idialog"></script>
<script type="text/javascript" src="../../scripts/datepicker/WdatePicker.js"></script>
<script type="text/javascript" src="../js/layout.js"></script>
<link  href="../../css/pagination.css" rel="stylesheet" type="text/css" />
<link href="../skin/default/style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
 #GridView1 td
 {
      padding-left:30px;
      border-bottom: 1px solid #e8e8e8;
    color: #666;
    line-height: 1.5em;
   
 }
 #GridView1 th{
    background: none repeat scroll 0 0 #f3f3f3;
    border-bottom: 1px solid #e1e1e1;
    color: #333;
    font-size: 12px;
    font-weight: 500;
    line-height: 1.5em;
    padding: 8px 0;
     ｝
</style>
</head>

<body class="mainbody">
<form id="form1" runat="server">
<!--导航栏-->
<div class="location">
  <a href="javascript:history.back(-1);" class="back"><i></i><span>返回上一页</span></a>
  <a href="../center.aspx" class="home"><i></i><span>首页</span></a>
  <i class="arrow"></i>
  <span>SQL查询</span>
</div>
<!--/导航栏-->

<!--工具栏-->
<div class="toolbar-wrap">
  <div id="floatHead" class="toolbar">
    
    <div class="l-list">
   
      <asp:TextBox ID="txtKeywords"    runat="server" CssClass="keyword" 
            TextMode="MultiLine" Height="65px" Width="516px" />
      <asp:LinkButton ID="lbtnSearch" runat="server" CssClass="btn-search" onclick="btnSearch_Click">查询</asp:LinkButton>
    </div>
  </div>
 </div>
<!--/工具栏-->

<!--列表-->
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" 
    GridLines="None" PageSize="50">
    <AlternatingRowStyle BackColor="White" />
    <EditRowStyle BackColor="#2461BF" />
    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
    <RowStyle BackColor="#EFF3FB" />
    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
    <SortedAscendingCellStyle BackColor="#F5F7FB" />
    <SortedAscendingHeaderStyle BackColor="#6D95E1" />
    <SortedDescendingCellStyle BackColor="#E9EBEF" />
    <SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<!--/列表-->
<div class="nlist-4" style="margin-left: 0px;">
  <h3><i class="site"></i>sql查询语名</h3>
  <ul>
    <li>1.查询疗程卡实用情况：select user_name,number,field from dt_users
right join dt_liaocheng
on dt_users.ID = dt_liaocheng.userid</li>
    <li>2、查询卡号是否可用：SELECT [id]
      ,[category_id]
      ,[SN]
      
      ,[CreatedDateTime]
      ,[content]
      
      ,[UsedStatus]
     
      
  FROM [ihongma].[dbo].[dt_Exchange] where sn='XXX'</li>
  
  </ul>
  
  <ul>
  
  </ul>
</div>

<!--内容底部-->
<div class="line20"></div>

<!--/内容底部-->
</form>
</body>
</html>